| SyStatChange |
| Logical Entity Name | SyStatChange |
| Default Table Name | SyStatChange |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SyStatChange Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| SyStudentID | int | NO | ||
| AdEnrollID | int | NO | ||
| Comment | varchar(255) | NO | ||
| EffectiveDate | datetime | NO | ||
| NewSyStatusID | int | NO | ||
| PrevSyStatusID | int | NO | ||
| NewSySchoolStatusID | int | NO | ||
| PrevSySchoolStatusID | int | NO | ||
| NewAdAttStatID | int | YES | ||
| PrevAdAttStatID | int | YES | ||
| InternalComm | text | NO | ||
| BeginDate | datetime | YES | ||
| ReturnDate | datetime | YES | ||
| Status | char(1) | YES | ||
| ModFlag | char(1) | YES | ||
| CmEventID | int | NO | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
SyStatChangeID |
int | NO | ||
| AdReasonID | int | YES | ||
| Type | char(1) | YES | ||
| PrevValue | varchar(30) | YES | ||
| NewValue | varchar(30) | YES | ||
AdTermID |
int | YES | ||
| StoredLDA | datetime | YES | ||
| NSLDSWithdrawalDate | datetime | YES | ||
| NewFAAttStatID | int | YES | ||
| PrevFAAttStatID | int | YES |
| SyStatChange Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SyStatChange_SyStatChangeID_U_C_IDX | PrimaryKey | SyStatChangeID |
| SyStatChange Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdTerm | Non-Identifying | Zero or One to Zero or More | FK_SyStatChange_AdTermID_AdTerm_AdTermID | AdTermID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| PlStatChange | Non-Identifying | One To Zero or More | FK_PlStatChange_PlStatChangeID_SyStatChange_SyStatChangeID | NO | YES | |||
| SaEnrollAcctStatus | Non-Identifying | One To Zero or More | FK_SaEnrollAcctStatus_SyStatChangeID_SyStatChange_SyStatChangeID | NO | YES | |||
| SyAudit_SaEnrollAcctStatus | Non-Identifying | One To Zero or More | FK_SyAudit_SaEnrollAcctStatus_SyStatChangeID_SyStatChange_SyStatChangeID | NO | YES |
| SyStatChange Check Constraints |
| Check Constraint Name | CheckConstraint |
| SyStatChange Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group | PRIMARY |
| SyStatChange Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.StudentSchoolStatusHistory |
NO | |||
| Physical (Microsoft SQL Server) dbo.SyStatChange |
NO |
| SyStatChange Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | StudentEnrollment |
| Logical | StudentJobPlacement |
| Logical | StudentPayments_Collections |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | System |
| SyStatChange Data Movement Rules |
| Name | Type | Rule Text/Value |